package com.jack.database_exp.mapper;
import com.jack.database_exp.bean.BuyInfo;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface BuyInfoMapper {
    @Insert("insert into buyInfo (BNo,GNo,BINum,BIPrice) values(#{BNo},#{GNo},#{BINum},#{BIPrice})")
    public int insertBuyInfo(BuyInfo buyInfo);
    @Select("select * from buyinfo")
    public List<BuyInfo> queryBuyInfos();
    @Select("select * from buyinfo where BNo = #{BNo}")
    public  List<BuyInfo> queryBuyInfoByBNo(Integer BNo);
}
